home *** CD-ROM | disk | FTP | other *** search
/ Magnum One / Magnum One (Mid-American Digital) (Disc Manufacturing).iso / d16 / winsql.arc / EXAMPLES.ARC / QUERY15.SQL < prev    next >
Encoding:
Text File  |  1991-06-02  |  101 b   |  5 lines

  1. delete from spj where 'Rome' =
  2.   (select city from j where j.jno = spj.jno);
  3.  
  4. select * from spj;
  5.